CREATE TABLE [dbo].[HotelPrice]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[HotelId] [int] NULL,
[RoomCategoryId] [int] NULL,
[Normal] [decimal] (18, 2) NULL,
[Weedken] [decimal] (18, 2) NULL,
[Holiday] [decimal] (18, 2) NULL,
[HolidayDate] [nvarchar] (100) COLLATE Vietnamese_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HotelPrice] ADD CONSTRAINT [PK_HotelPrice] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
